SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweEmbargos
AS
SELECT        idEmbargo AS ID, Desde, Hasta, TipoEmbargo, Juzgado, Expediente, MontoTotal, MontoMensual, MontoDescontado, Porcentaje, UltimaLiquidacionDefinitiva, 
                         FormulaDeDescuento, CuentaDestino, Banco, Agente
FROM            dbo.tb_Embargos
GO
GRANT SELECT ON  [dbo].[vweEmbargos] TO [AdministracionSagenet]
GRANT INSERT ON  [dbo].[vweEmbargos] TO [AdministracionSagenet]
GRANT DELETE ON  [dbo].[vweEmbargos] TO [AdministracionSagenet]
GRANT UPDATE ON  [dbo].[vweEmbargos] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vweEmbargos] TO [adm-sage]
GRANT INSERT ON  [dbo].[vweEmbargos] TO [adm-sage]
GRANT DELETE ON  [dbo].[vweEmbargos] TO [adm-sage]
GRANT UPDATE ON  [dbo].[vweEmbargos] TO [adm-sage]
GO
